import cx_Oarcle as cxo
ll=cxo.connect('scott/123456@192.168.0.65/ORCL')
c=ll.cursor()
lz=c.execute("select column_name,data_type,data_precision,data_scale from user_tab_columns where table_name="+tname)

path=C:\Users\Administrator\Desktop
with open(path) as w:
    for ii in w:
        ii=ii.replace('""','NULL')
        ii=ii.replace('"','')
        zz=ii.split(',')
        counter=0
        sql='insert into emp values('
        for mm in zz
            if counter in[1,2]:
                mm='\''+mm+'\''
            if counter==4:
                mm='to_date('+'\''+mm+'\''+",'yyyy/mm/dd')"

            sql +=mm+','
            counter +=1

        sql=sql[:-1]+')'
        c.execute(sql)
        ll.commit()
c.close()
ll.close()
        
